Computer science Lesson Plan
Class: 5 - Lesson:6.2 Formula usage in spreadsheet,Freeze rows/columns,Find and Replace.

Purpose: Students should learn the special features of spreadsheets,Freeze the rows/columns,Find and Replace.

No. of Classes

One or two classes (Teacher's decision).

Material Required

Open office(Spreadsheet).

Curriculum Content
  • 4) Other applications of computers.
  • 5.2.17) Freeze rows and columns.
  • 5.2.18) Sort sheet by columns.
  • 5.2.14)Find, replace.
    •

    Prior knowledge

    Students should know about basics of spreadsheets.

    Exercise

    Exercise:1


    Create a new spreadsheet and name it as ‘student mark sheet.ods’. Use formulae to calculate Total, Average and Result.

    Exercise:2


    How do you sort and freeze rows/columns in a spreadsheet?.

    Exercise:3


    How do you Find and Replace words?.

    Solution


  • Link to copy the solution spreadsheet
  • Link to copy the solution video
  • Link to copy the solution video

    • Teacher's Instruction
    1. Teachers should ensure that the students understand simple operations like Addition, Subtraction, Multiplication, and Division, before giving the Exercise.
    2. Students should identify the number of rows and columns before creating the spreadsheet.
    3. Teachers should explain about the autofill feature (drag the autofill handle at the bottom right of a cell) and how this is useful in filling dates, days, or S.No).
    4. Teachers should ensure that all Students understand the freezing rows and columns feature and sort columns, and also how to highlight the header row by using shadows for that row.
    5. To know the formula of a specific cell, the formula bar at the top left of the sheet can be referred to.